Power BI Fundamentals
Primavera P6 Data Integration
Interactive Dashboard Development
Labour Units Monitoring
Cost Performance Index (CPI)
Project Delay Analysis
Power BI Desktop Installation
Excel Data Preparation
Project Cost Visualisation
Project Progress Tracking
Schedule Performance Index (SPI)
Project Performance Reporting
Effective project monitoring and controlling are essential for ensuring that construction projects are completed within the approved budget, planned schedule, and required performance standards. With the increasing use of data-driven decision-making in the construction industry, professionals need the ability to transform complex project data into meaningful insights. Project Monitoring and Controlling Using Power BI is a practical training course designed to help construction and project management professionals develop interactive dashboards and visual reports using Microsoft Power BI.
This course is suitable for Planning Engineers, Project Controls Engineers, Project Managers, Quantity Surveyors, Cost Engineers, Construction Managers, and other AEC professionals who want to strengthen their project monitoring, reporting, and analytical skills. It is particularly beneficial for professionals working with Primavera P6 who want to integrate project scheduling and progress data with Power BI for effective project performance monitoring.
The course begins with an introduction to Microsoft Power BI, including its importance for project professionals, software downloading and installation, and an overview of the Power BI Desktop interface, workspace, and configuration options. Participants will become familiar with the essential tools and features required to develop professional project dashboards.
The main focus of the training is a hands-on project dashboard development exercise, where participants learn how to export project data from Primavera P6, prepare and modify Excel data, and import the information into Power BI Desktop. Through practical demonstrations, they will learn how to organise data tables, configure dashboard layouts, and create meaningful visualisations for project monitoring.
Participants will develop dashboards to monitor total project cost, total labour units, actual labour units, project progress percentages, and current project progress. The training also covers the development of Cost Performance Index (CPI) and Schedule Performance Index (SPI) dashboards, enabling professionals to evaluate cost and schedule performance. Additionally, participants will learn how to visualise whether a project is ahead of or behind schedule, supporting more informed project control and reporting decisions.
By the end of this course, participants will have practical knowledge of integrating Primavera P6 data with Microsoft Power BI and transforming project information into interactive visual dashboards. They will be better equipped to analyse project performance, communicate progress effectively, identify potential delays, and support data-driven decision-making throughout the project lifecycle.
Note: This course is designed for practical professional development and skill enhancement. Participants will receive a certificate of completion, and applicable APC/CPD hours may be claimed subject to the requirements of the relevant professional institution.
How to Export Data from Primavera P6 for Power BI
Columns Modification for Excel Data
Import Data from Excel to Power BI Desktop
How to Create a Folder to Organise Tables
Canvas Settings and Dashboard Name
Total Project Cost Visualisation
Total Labour Units Visualisation
Actual Labour Units Visualisation
Project Progress Percentages
Project Current Progress Data
Cost Performance Index (CPI) Dashboard
12.Schedule Performance Index (SPI) Dashboard
Delay / Ahead of Schedule
0 Reviews
Waheed Anwar
Primavera Instructor
As a certified trainer in Primavera P6 and Microsoft Project Professional, I bring over 16 years of hands-on experience in project management, backed by a Master's in Project Management, an MBA, and a Civil Engineering background. Since 2008, I’ve delivered over 400 corporate training sessions across sectors like Construction, Electrical, Mechanical, IT, and Manufacturing. My training is tailored, practical, and results-driven—focused on real-world application and designed to equip professionals with the tools and confidence to manage complex projects effectively. Your success and satisfaction remain my top priority.
